﻿///***************************************************************
/// 시  스  템 : Updms.Dvd.Dac
/// 단위시스템 : DVD
/// 계      층 : Data Access Layer
/// 프로그램명 : Dvd_Dac_UPDMS_DVD_REPORT_Dvd3010p
/// 파  일  명 : Dvd_Dac_UPDMS_DVD_REPORT_Dvd3010p.cs
/// 설      명 : DVD요약정보 -> 각 챠트별 상세리스트 팝업
///***************************************************************
/// 수정ID 일자       이름     내용
///---------------------------------------------------------------
/// CH001  2008-09-08 송시명   최초 작성
///***************************************************************
using System.Data;
using System.Data.SqlClient;
using System.EnterpriseServices;
using System.Runtime.InteropServices;


namespace Updms.Dvd.Dac
{
	[ComVisible(true)]
	[Transaction(TransactionOption.Supported)]
	[JustInTimeActivation(true)]
	public class Dvd_Dac_UPDMS_DVD_REPORT_Dvd3010p : Base.AppFramework.DacBase
	{
		public Dvd_Dac_UPDMS_DVD_REPORT_Dvd3010p()
		{
		}

		#region NT [GetListByActress]

		/// <summary>
		/// 배우별리스트팝업
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetListByActress(string ls_keyword)
		{
			string strSql = "usp_UPDMS_DVD_REPORT_Dvd3010p_Get_List_By_Actress1";

			SqlParameter[] paramArray =
			{
				new SqlParameter("ls_actress1", ls_keyword)
			};
		
			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_DVD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}
		
		#endregion

		#region NT [GetListByRate]

		/// <summary>
		/// 평점별리스트팝업
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetListByRate(string ls_keyword)
		{
			string strSql = "usp_UPDMS_DVD_REPORT_Dvd3010p_Get_List_By_Rate";

			SqlParameter[] paramArray =
			{
				new SqlParameter("ls_rate", ls_keyword)
			};

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_DVD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion

		#region NT [GetListByStudio]

		/// <summary>
		/// 스튜디오별리스트팝업
		/// </summary>
		/// <param name="lo_dp"></param>
		/// <returns></returns>
		[AutoComplete]
		public DataSet GetListByStudio(string ls_keyword)
		{
			string strSql = "usp_UPDMS_DVD_REPORT_Dvd3010p_Get_List_By_Studio";

			SqlParameter[] paramArray =
			{
				new SqlParameter("ls_studio", ls_keyword)
			};

			DataSet ds = new DataSet();
			return _agent.Fill(strSql, "UPDMS_DVD_REPORT", ds, paramArray, CommandType.StoredProcedure);
		}

		#endregion


	}
}
